<?php
$content['data'] = query(
	'SELECT 
		t.id AS id, 
		t.content AS content, 
		t.title AS title, 
		t.created AS created, 
		t.description AS description, 
		tc.description AS categoryDescription 
	FROM text AS t 
	LEFT OUTER JOIN textcategory AS tc ON t.textcategory_id = tc.id 
	ORDER BY t.created DESC 
	LIMIT 0,8',
	null);
?>